using System.Data;
using System.Data.OracleClient;
namespace WPFExcelReport
{

    public partial class VVAKOLL
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {

            switch (app.company)
            {
                case "YGR":
                case "AFS":
                case "TST":
                case "UBT":
                case "SXN":
                default:
           #region=========
                  dwReturn["VAKMANDANT"]="00";
                dwReturn["VAKKOLL"]="     ";
                dwReturn["VAKBEZ"]="                    ";
                dwReturn["VAKOBERKOLL"]="     ";
                dwReturn["VAKDATVON"]="20140915";
                dwReturn["VAKDATBIS"] = "20501230";
                dwReturn["VAKSPERRDAT"]="0";
                dwReturn["VAKKUNDNR"]="        ";
                dwReturn["VAKBEM"]="                                        ";
                dwReturn["VAKANTEIL1"]="0";
                dwReturn["VAKANTEIL2"]="0";
                dwReturn["VAKANTEIL3"]="0";
                dwReturn["VAKANTEIL4"]="0";
                dwReturn["VAKANTEIL5"]="0";
                dwReturn["VAKANTEIL6"]="0";
                dwReturn["VAKANTEIL7"]="0";
                dwReturn["VAKANTEIL8"]="0";
                dwReturn["VAKANTEIL9"]="0";
                dwReturn["VAKANTEIL10"]="0";
                dwReturn["VAKANTEIL11"]="0";
                dwReturn["VAKANTEIL12"]="0";
                dwReturn["VAKAENDZL"]="0";
                dwReturn["VAKAENDBEN"]="        ";
                dwReturn["VAKAENDDAT"]="0";
                dwReturn["VAKNEUBEN"]="        ";
                dwReturn["VAKNEUDAT"]="0";
                dwReturn["VAKLFSGRDA"]="0";
                dwReturn["VAKLFSGRDB"]="0";
                dwReturn["VAKLFSGRDC"]="0";
                dwReturn["VAKMEEH"]="MTR";
                dwReturn["VAKMEEHGRP"]="1";
                dwReturn["VAKMEEHFKT"]="000001000000";
                dwReturn["VAKLTERMIN1"]="0";
                dwReturn["VAKLTERMIN2"]="0";
                dwReturn["VAKLTERMIN3"]="0";
                dwReturn["VAKLTERMIN4"]="0";
                dwReturn["VAKLTERMIN5"]="0";
                dwReturn["VAKLTERMIN6"]="0";
                dwReturn["VAKLTERMIN7"]="0";
                dwReturn["VAKLTERMIN8"]="0";
                dwReturn["VAKLTERMIN9"]="0";
                dwReturn["VAKLTERMIN10"]="0";
                dwReturn["VAKLTERMIN11"]="0";
                dwReturn["VAKLTERMIN12"]="0";
                dwReturn["VAKFIX"]=" ";
                dwReturn["VAKARTGEN"]=" ";
                dwReturn["VAKSTVON1"]="0";
                dwReturn["VAKSTBIS1"]="0";
                dwReturn["VAKPRKZ1"]=" ";
                dwReturn["VAKSTVON2"]="0";
                dwReturn["VAKSTBIS2"]="0";
                dwReturn["VAKPRKZ2"]=" ";
                dwReturn["VAKSTVON3"]="0";
                dwReturn["VAKSTBIS3"]="0";
                dwReturn["VAKPRKZ3"]=" ";
                dwReturn["VAKSTVON4"]="0";
                dwReturn["VAKSTBIS4"]="0";
                dwReturn["VAKPRKZ4"]=" ";
                dwReturn["VAKMODNEU"]=" ";
                dwReturn["VAKPSTVO"]="0";
                dwReturn["VAKPSTHI"]="0";
                dwReturn["VAKPANZEL"]="0";
                dwReturn["VAKPRZUSCHL"]=" ";
                dwReturn["VAKKM1"]="     ";
                dwReturn["VAKVOM1"]="0";
                dwReturn["VAKHIM1"]="0";
                dwReturn["VAKELM1"]="0";
                dwReturn["VAKSTM1"]="0";
                dwReturn["VAKGRM1"]="          ";
                dwReturn["VAKKZM1"]=" ";
                dwReturn["VAKFBM1"]="          ";
                dwReturn["VAKPTM1"]="   ";
                dwReturn["VAKPKM1"]="  ";
                dwReturn["VAKLZM1"]="0";
                dwReturn["VAKVSM1"]="   ";
                dwReturn["VAKSPM1"]="   ";
                dwReturn["VAKAGM1"]=" ";
                dwReturn["VAKBZM1"]="  ";
                dwReturn["VAKKM2"]="     ";
                dwReturn["VAKVOM2"]="0";
                dwReturn["VAKHIM2"]="0";
                dwReturn["VAKELM2"]="0";
                dwReturn["VAKSTM2"]="0";
                dwReturn["VAKGRM2"]="          ";
                dwReturn["VAKKZM2"]=" ";
                dwReturn["VAKFBM2"]="          ";
                dwReturn["VAKPTM2"]="   ";
                dwReturn["VAKPKM2"]="  ";
                dwReturn["VAKLZM2"]="0";
                dwReturn["VAKAGM2"]=" ";
                dwReturn["VAKBZM2"]="  ";
                dwReturn["VAKKM3"]="     ";
                dwReturn["VAKVOM3"]="0";
                dwReturn["VAKHIM3"]="0";
                dwReturn["VAKELM3"]="0";
                dwReturn["VAKSTM3"]="0";
                dwReturn["VAKGRM3"]="          ";
                dwReturn["VAKKZM3"]=" ";
                dwReturn["VAKFBM3"]="          ";
                dwReturn["VAKPTM3"]="   ";
                dwReturn["VAKPKM3"]="  ";
                dwReturn["VAKLZM3"]="0";
                dwReturn["VAKAGM3"]=" ";
                dwReturn["VAKBZM3"]="  ";
                dwReturn["VAKPTC"]="   ";
                dwReturn["VAKPKC"]="  ";
                dwReturn["VAKLZC"]="0";
                dwReturn["VAKVSC"]="   ";
                dwReturn["VAKSPC"]="   ";
                dwReturn["VAKCKZC"]=" ";
                dwReturn["VAKAUFTR"]="0";
                dwReturn["VAKANGVON"]="0";
                dwReturn["VAKANGBIS"]="0";
                dwReturn["VAKSAMVON"]="0";
                dwReturn["VAKSAMBIS"]="0";
                dwReturn["VAKSAMPT1"]="   ";
                dwReturn["VAKSAMPT2"]="   ";
                dwReturn["VAKSAMPT3"]="   ";
                dwReturn["VAKSAMPT4"]="   ";
                dwReturn["VAKSAMPT5"]="   ";
                dwReturn["VAKSAMPT6"]="   ";
                dwReturn["VAKSAMPT7"]="   ";
                dwReturn["VAKSAMPT8"]="   ";
                dwReturn["VAKAUFVON"]="0";
                dwReturn["VAKAUFBIS"]="0";
                dwReturn["VAKFILLER"]="                                                         ";

                    #endregion
                    break;
            }
        }  
        public void InsertVAKOLL(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            dwData["VAKNEUBEN"] = app.User;
            dwData["VAKNEUDAT"] = date; 
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "AFS":
                case "TST":
                case "UBT":
                case "SXN":
                default:
                    or1.CommandText = "INSERT INTO VAKOLL(VAKMANDANT, VAKKOLL, VAKBEZ, VAKOBERKOLL, VAKDATVON, VAKDATBIS, VAKSPERRDAT, VAKKUNDNR, VAKBEM, VAKANTEIL1, VAKANTEIL2, VAKANTEIL3, VAKANTEIL4, VAKANTEIL5, VAKANTEIL6, VAKANTEIL7, VAKANTEIL8, VAKANTEIL9, VAKANTEIL10, VAKANTEIL11, VAKANTEIL12, VAKAENDZL, VAKAENDBEN, VAKAENDDAT, VAKNEUBEN, VAKNEUDAT, VAKLFSGRDA, VAKLFSGRDB, VAKLFSGRDC, VAKMEEH, VAKMEEHGRP, VAKMEEHFKT, VAKLTERMIN1, VAKLTERMIN2, VAKLTERMIN3, VAKLTERMIN4, VAKLTERMIN5, VAKLTERMIN6, VAKLTERMIN7, VAKLTERMIN8, VAKLTERMIN9, VAKLTERMIN10, VAKLTERMIN11, VAKLTERMIN12, VAKFIX, VAKARTGEN, VAKSTVON1, VAKSTBIS1, VAKPRKZ1, VAKSTVON2, VAKSTBIS2, VAKPRKZ2, VAKSTVON3, VAKSTBIS3, VAKPRKZ3, VAKSTVON4, VAKSTBIS4, VAKPRKZ4, VAKMODNEU, VAKPSTVO, VAKPSTHI, VAKPANZEL, VAKPRZUSCHL, VAKKM1, VAKVOM1, VAKHIM1, VAKELM1, VAKSTM1, VAKGRM1, VAKKZM1, VAKFBM1, VAKPTM1, VAKPKM1, VAKLZM1, VAKVSM1, VAKSPM1, VAKAGM1, VAKBZM1, VAKKM2, VAKVOM2, VAKHIM2, VAKELM2, VAKSTM2, VAKGRM2, VAKKZM2, VAKFBM2, VAKPTM2, VAKPKM2, VAKLZM2, VAKAGM2, VAKBZM2, VAKKM3, VAKVOM3, VAKHIM3, VAKELM3, VAKSTM3, VAKGRM3, VAKKZM3, VAKFBM3, VAKPTM3, VAKPKM3, VAKLZM3, VAKAGM3, VAKBZM3, VAKPTC, VAKPKC, VAKLZC, VAKVSC, VAKSPC, VAKCKZC, VAKAUFTR, VAKANGVON, VAKANGBIS, VAKSAMVON, VAKSAMBIS, VAKSAMPT1, VAKSAMPT2, VAKSAMPT3, VAKSAMPT4, VAKSAMPT5, VAKSAMPT6, VAKSAMPT7, VAKSAMPT8, VAKAUFVON, VAKAUFBIS, VAKFILLER)"
                        +"VALUES(:VAKMANDANT:,:VAKKOLL:,:VAKBEZ:,:VAKOBERKOLL:,:VAKDATVON:,:VAKDATBIS:,:VAKSPERRDAT:,:VAKKUNDNR:,:VAKBEM:,:VAKANTEIL1:,:VAKANTEIL2:,:VAKANTEIL3:,:VAKANTEIL4:,:VAKANTEIL5:,:VAKANTEIL6:,:VAKANTEIL7:,:VAKANTEIL8:,:VAKANTEIL9:,:VAKANTEIL10:,:VAKANTEIL11:,:VAKANTEIL12:,:VAKAENDZL:,:VAKAENDBEN:,:VAKAENDDAT:,:VAKNEUBEN:,:VAKNEUDAT:,:VAKLFSGRDA:,:VAKLFSGRDB:,:VAKLFSGRDC:,:VAKMEEH:,:VAKMEEHGRP:,:VAKMEEHFKT:,:VAKLTERMIN1:,:VAKLTERMIN2:,:VAKLTERMIN3:,:VAKLTERMIN4:,:VAKLTERMIN5:,:VAKLTERMIN6:,:VAKLTERMIN7:,:VAKLTERMIN8:,:VAKLTERMIN9:,:VAKLTERMIN10:,:VAKLTERMIN11:,:VAKLTERMIN12:,:VAKFIX:,:VAKARTGEN:,:VAKSTVON1:,:VAKSTBIS1:,:VAKPRKZ1:,:VAKSTVON2:,:VAKSTBIS2:,:VAKPRKZ2:,:VAKSTVON3:,:VAKSTBIS3:,:VAKPRKZ3:,:VAKSTVON4:,:VAKSTBIS4:,:VAKPRKZ4:,:VAKMODNEU:,:VAKPSTVO:,:VAKPSTHI:,:VAKPANZEL:,:VAKPRZUSCHL:,:VAKKM1:,:VAKVOM1:,:VAKHIM1:,:VAKELM1:,:VAKSTM1:,:VAKGRM1:,:VAKKZM1:,:VAKFBM1:,:VAKPTM1:,:VAKPKM1:,:VAKLZM1:,:VAKVSM1:,:VAKSPM1:,:VAKAGM1:,:VAKBZM1:,:VAKKM2:,:VAKVOM2:,:VAKHIM2:,:VAKELM2:,:VAKSTM2:,:VAKGRM2:,:VAKKZM2:,:VAKFBM2:,:VAKPTM2:,:VAKPKM2:,:VAKLZM2:,:VAKAGM2:,:VAKBZM2:,:VAKKM3:,:VAKVOM3:,:VAKHIM3:,:VAKELM3:,:VAKSTM3:,:VAKGRM3:,:VAKKZM3:,:VAKFBM3:,:VAKPTM3:,:VAKPKM3:,:VAKLZM3:,:VAKAGM3:,:VAKBZM3:,:VAKPTC:,:VAKPKC:,:VAKLZC:,:VAKVSC:,:VAKSPC:,:VAKCKZC:,:VAKAUFTR:,:VAKANGVON:,:VAKANGBIS:,:VAKSAMVON:,:VAKSAMBIS:,:VAKSAMPT1:,:VAKSAMPT2:,:VAKSAMPT3:,:VAKSAMPT4:,:VAKSAMPT5:,:VAKSAMPT6:,:VAKSAMPT7:,:VAKSAMPT8:,:VAKAUFVON:,:VAKAUFBIS:,:VAKFILLER:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }

            Connect2Proxy(or1);
        }
        public DataSet QueryVAKOLL(DataRow dwData, int option = 1)
        { 
          
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                
                case 0: SResult = QVAK00(dwData); break;
                case 1: SResult = QVAK01(dwData); break;
                case 2: SResult = QVAK02(dwData); break;
                case -1:SResult = QVAK_1(dwData);  break;
                case 99: SResult = QVAK99(dwData); break; 
            }
         
           return SResult;
        }
        public DataSet QVAK99(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VAKOLL  WHERE ROWNUM<50"; 
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVAK00(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VAKOLL WHERE  ROWNUM<2 ";
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVAK01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VAKOLL WHERE  VAKMANDANT=:VAKMANDANT: AND VAKKOLL=:VAKKOLL:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVAK02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VAKOLL WHERE  VAKMANDANT=:VAKMANDANT: AND VAKKOLL LIKE '%" + dwData["VAKKOLL"].ToString() + "%'";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVAK03(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT VAKKOLL FROM VAKOLL WHERE  VAKMANDANT=:VAKMANDANT: AND VAKKOLL=:VAKKOLL:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        } 

        public DataSet QVAK_1(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT DISTINCT VAKKOLL,VAKBEZ,VAKSPERRDAT FROM VAKOLL WHERE VAKMANDANT=:VAKMANDANT: AND VAKKM1=:VAKKM1:"
                       + " ORDER BY VAKKOLL";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        } 
       
        public void DeleteVAKOLL(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM VAKOLL   WHERE  VAKMANDANT=:VAKMANDANT: AND VAKKOLL=:VAKKOLL:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }
        public void UVAK02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VAKOLL SET VAKSPERRDAT=:VAKSPERRDAT:  WHERE  VAKMANDANT=:VAKMANDANT: AND VAKKOLL=:VAKKOLL:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UpdateVAKOLL(DataRow dwData,  int option = 1)
        { 
           
            or1 = OracleDB.CreateCommand();
            if (option == 0)
            {
                switch (app.company)
                {
                    case "YGR":
                    case "AFS":
                    case "TST":
                    case "UBT":
                    case "SXN":
                    default:
                        option = 1;
                        break; 
                }
            }
            switch (option)
            {
                case 1:
                    #region====Command====
                    or1.CommandText = "UPDATE VAKOLL SET "
                    + "VAKMANDANT= :VAKMANDANT:,"
                    + "VAKKOLL= :VAKKOLL:,"
                    + "VAKBEZ= :VAKBEZ:,"
                    + "VAKOBERKOLL= :VAKOBERKOLL:,"
                    + "VAKDATVON= :VAKDATVON:,"
                    + "VAKDATBIS= :VAKDATBIS:,"
                    + "VAKSPERRDAT= :VAKSPERRDAT:,"
                    + "VAKKUNDNR= :VAKKUNDNR:,"
                    + "VAKBEM= :VAKBEM:,"
                    + "VAKANTEIL1= :VAKANTEIL1:,"
                    + "VAKANTEIL2= :VAKANTEIL2:,"
                    + "VAKANTEIL3= :VAKANTEIL3:,"
                    + "VAKANTEIL4= :VAKANTEIL4:,"
                    + "VAKANTEIL5= :VAKANTEIL5:,"
                    + "VAKANTEIL6= :VAKANTEIL6:,"
                    + "VAKANTEIL7= :VAKANTEIL7:,"
                    + "VAKANTEIL8= :VAKANTEIL8:,"
                    + "VAKANTEIL9= :VAKANTEIL9:,"
                    + "VAKANTEIL10= :VAKANTEIL10:,"
                    + "VAKANTEIL11= :VAKANTEIL11:,"
                    + "VAKANTEIL12= :VAKANTEIL12:,"
                    + "VAKAENDZL= :VAKAENDZL:,"
                    + "VAKAENDBEN= :VAKAENDBEN:,"
                    + "VAKAENDDAT= :VAKAENDDAT:,"
                    + "VAKLFSGRDA= :VAKLFSGRDA:,"
                    + "VAKLFSGRDB= :VAKLFSGRDB:,"
                    + "VAKLFSGRDC= :VAKLFSGRDC:,"
                    + "VAKMEEH= :VAKMEEH:,"
                    + "VAKMEEHGRP= :VAKMEEHGRP:,"
                    + "VAKMEEHFKT= :VAKMEEHFKT:,"
                    + "VAKLTERMIN1= :VAKLTERMIN1:,"
                    + "VAKLTERMIN2= :VAKLTERMIN2:,"
                    + "VAKLTERMIN3= :VAKLTERMIN3:,"
                    + "VAKLTERMIN4= :VAKLTERMIN4:,"
                    + "VAKLTERMIN5= :VAKLTERMIN5:,"
                    + "VAKLTERMIN6= :VAKLTERMIN6:,"
                    + "VAKLTERMIN7= :VAKLTERMIN7:,"
                    + "VAKLTERMIN8= :VAKLTERMIN8:,"
                    + "VAKLTERMIN9= :VAKLTERMIN9:,"
                    + "VAKLTERMIN10= :VAKLTERMIN10:,"
                    + "VAKLTERMIN11= :VAKLTERMIN11:,"
                    + "VAKLTERMIN12= :VAKLTERMIN12:,"
                    + "VAKFIX= :VAKFIX:,"
                    + "VAKARTGEN= :VAKARTGEN:,"
                    + "VAKSTVON1= :VAKSTVON1:,"
                    + "VAKSTBIS1= :VAKSTBIS1:,"
                    + "VAKPRKZ1= :VAKPRKZ1:,"
                    + "VAKSTVON2= :VAKSTVON2:,"
                    + "VAKSTBIS2= :VAKSTBIS2:,"
                    + "VAKPRKZ2= :VAKPRKZ2:,"
                    + "VAKSTVON3= :VAKSTVON3:,"
                    + "VAKSTBIS3= :VAKSTBIS3:,"
                    + "VAKPRKZ3= :VAKPRKZ3:,"
                    + "VAKSTVON4= :VAKSTVON4:,"
                    + "VAKSTBIS4= :VAKSTBIS4:,"
                    + "VAKPRKZ4= :VAKPRKZ4:,"
                    + "VAKMODNEU= :VAKMODNEU:,"
                    + "VAKPSTVO= :VAKPSTVO:,"
                    + "VAKPSTHI= :VAKPSTHI:,"
                    + "VAKPANZEL= :VAKPANZEL:,"
                    + "VAKPRZUSCHL= :VAKPRZUSCHL:,"
                    + "VAKKM1= :VAKKM1:,"
                    + "VAKVOM1= :VAKVOM1:,"
                    + "VAKHIM1= :VAKHIM1:,"
                    + "VAKELM1= :VAKELM1:,"
                    + "VAKSTM1= :VAKSTM1:,"
                    + "VAKGRM1= :VAKGRM1:,"
                    + "VAKKZM1= :VAKKZM1:,"
                    + "VAKFBM1= :VAKFBM1:,"
                    + "VAKPTM1= :VAKPTM1:,"
                    + "VAKPKM1= :VAKPKM1:,"
                    + "VAKLZM1= :VAKLZM1:,"
                    + "VAKVSM1= :VAKVSM1:,"
                    + "VAKSPM1= :VAKSPM1:,"
                    + "VAKAGM1= :VAKAGM1:,"
                    + "VAKBZM1= :VAKBZM1:,"
                    + "VAKKM2= :VAKKM2:,"
                    + "VAKVOM2= :VAKVOM2:,"
                    + "VAKHIM2= :VAKHIM2:,"
                    + "VAKELM2= :VAKELM2:,"
                    + "VAKSTM2= :VAKSTM2:,"
                    + "VAKGRM2= :VAKGRM2:,"
                    + "VAKKZM2= :VAKKZM2:,"
                    + "VAKFBM2= :VAKFBM2:,"
                    + "VAKPTM2= :VAKPTM2:,"
                    + "VAKPKM2= :VAKPKM2:,"
                    + "VAKLZM2= :VAKLZM2:,"
                    + "VAKAGM2= :VAKAGM2:,"
                    + "VAKBZM2= :VAKBZM2:,"
                    + "VAKKM3= :VAKKM3:,"
                    + "VAKVOM3= :VAKVOM3:,"
                    + "VAKHIM3= :VAKHIM3:,"
                    + "VAKELM3= :VAKELM3:,"
                    + "VAKSTM3= :VAKSTM3:,"
                    + "VAKGRM3= :VAKGRM3:,"
                    + "VAKKZM3= :VAKKZM3:,"
                    + "VAKFBM3= :VAKFBM3:,"
                    + "VAKPTM3= :VAKPTM3:,"
                    + "VAKPKM3= :VAKPKM3:,"
                    + "VAKLZM3= :VAKLZM3:,"
                    + "VAKAGM3= :VAKAGM3:,"
                    + "VAKBZM3= :VAKBZM3:,"
                    + "VAKPTC= :VAKPTC:,"
                    + "VAKPKC= :VAKPKC:,"
                    + "VAKLZC= :VAKLZC:,"
                    + "VAKVSC= :VAKVSC:,"
                    + "VAKSPC= :VAKSPC:,"
                    + "VAKCKZC= :VAKCKZC:,"
                    + "VAKAUFTR= :VAKAUFTR:,"
                    + "VAKANGVON= :VAKANGVON:,"
                    + "VAKANGBIS= :VAKANGBIS:,"
                    + "VAKSAMVON= :VAKSAMVON:,"
                    + "VAKSAMBIS= :VAKSAMBIS:,"
                    + "VAKSAMPT1= :VAKSAMPT1:,"
                    + "VAKSAMPT2= :VAKSAMPT2:,"
                    + "VAKSAMPT3= :VAKSAMPT3:,"
                    + "VAKSAMPT4= :VAKSAMPT4:,"
                    + "VAKSAMPT5= :VAKSAMPT5:,"
                    + "VAKSAMPT6= :VAKSAMPT6:,"
                    + "VAKSAMPT7= :VAKSAMPT7:,"
                    + "VAKSAMPT8= :VAKSAMPT8:,"
                    + "VAKAUFVON= :VAKAUFVON:,"
                    + "VAKAUFBIS= :VAKAUFBIS:,"
                    + "VAKFILLER= :VAKFILLER: "
                        + " WHERE  "
                        + "  VAKMANDANT=:VAKMANDANT: AND VAKKOLL=:VAKKOLL:";
                    #endregion

                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
